home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / tallyuse.sql < prev    next >
Text File  |  2000-05-12  |  704b  |  20 lines
  1. /* RCSVER $Id: tallyuse.sql,v 1.1 2000-02-08 14:46:54-06 randy Exp $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:    tallyuse.sql
  6. * Date:        02/07/2000
  7. * memo:        Randy Wood
  8. * Description:    Create the tallyuse table.
  9. * Changes:
  10. ************************************************************************* */
  11. CREATE TABLE tallyuse
  12. (
  13.     det_seq_num    NUMBER(38)
  14.         CONSTRAINT ref1_tallyuse REFERENCES mstrrec(det_seq_num),
  15.     farebox_glid    NUMBER(38),
  16.       conv_date       DATE,         /* Date for this record */
  17.     ttype        NUMBER(38),        /* Tally type */
  18.     tcount    NUMBER(38)        /* Tally count */
  19. );
  20.